USE [MyCarat]
GO
/****** Object:  StoredProcedure [dbo].[sp_GetPic]    Script Date: 05/30/2012 18:25:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
if exists(select * from sysobjects where id=object_id('sp_GetPic') )
        drop proc sp_GetPic
GO
create proc [dbo].[sp_GetPic]
  @id varchar(35)

  as
  -- begin tran
   
   select    
            imgID  ,
			imgURL
    from pics
    where ID= @id 
             
     
   
   
   
--  commit tran  
    
    